Problem with query unit!

07 Jun '12, 03:50 PM
74,444 Views
No Forum Badges

Hi, i'm trying to display a result of a query, the query is the follow. . . .

select r.data,c.nome,s.nome from richiesta as r,corso as c,studente as s where r.corso_oid=c.oid and r.studente_oid=s.oid and corso.docente_oid=:Docente;

The idea is to display in one unit the result of this query, I suppose to do that using a query unit with static select. . Searching the wiki for query unit i find out a tutorial showing me that i can use input parameters and out put parameters. .

So I've setted up a input parameters called Docente and coupled it correctly, so I've setted up the output for each columns in the select. but when i run the application an error occourse telling me that it can find a parameter called Docente!

So I can't figure out how to fix it, I've also no idea of wich part is giving me the error, is the query? or the parameters?

Thanks in advance!

Salve, sto cercando di visualizzare il risultato di una query in una query unit, ho creato i parametri di output e di input, ho fatto correttamente il coupling ma visualizzo un errore quando eseguo la app. mi dice che non trova il parametro che ho messo come parametro di input! Però non riesco a capire dove sia il problema, se sia colpa del parametro o della query sql che ho inserito!

Grazie in anticipo a tutti!

 
x 0
Follow
Answer Answer at this question and get points!
No Forum Badges

I've resolved the problem! probably was about the name of the parameter in input and in the query!!

Fixed

   
x 0
Answer at this question and get points!

Related questions

502 proxy error-generate and run Acceder a diferentes site views/ Acces to diferents site views Adding and deleting from the database Add to Bag link in ACME Agregar boton de cambio de contraseña en el login Alimentar graficas con base de datos any webratio book ? Asking For a Book Atributos Condicionales heredados Attribute comparison in a selector unit [beginner] - How to store and browse data collected with BPM app? Business object data Cancellare campi e tabelle dal database Cannot add a Database in the Domain Model Cannot connect to MySQL Cannot insert an entity in the database Cannot invoke method selectSingleNode() on null object Can't generate and run database or start tomcat server! Change uplod directory and protect anauthorized access to files Clarification about the NoOperation unit Codigo QR Como hacer un menu en webratio? Como mostrar una imagen en una lista o en la componente detalles? Como recuperar todos los atributos de una relacion N:N y insertar registros? Conditional Expression "greater than 0" on null fields Conexion a Oracle 12g Connection refused. Connect more query unit connect to Cloud Content module page variable won't assign. Convert data in a Calculated attribute Convert selector component result to single value coupled mandatory fields Creación DB Apache Derby - Modelado BPMN Create Unit with Date (Year only) Criptare dati sensibili nel database Custom Attributes Condition Database Database connection, Host and Port number Database List is not showing up in App Emulator Database password encrypting Database properties Database resource consumption Database Tables Creation After Remote Deploy Data is always created doubled Data Management: Updating Data - Attachments - Updating Data Sample Project Final DB in Data Service Project Deploy in Cloud Amazon Beanstalk with Postgres Description: Unknown tag 'wr:LinkResource' Dudas sobre modelado(Data Flow,Forms y Operation Create) Dynamic data type Empty record mistakenly saved en_US codify problem Error updating metadata process EverLasting error "The TCP/IP connection to the host has failed. Connection refused" Execute truncate sql query Export XML external link.= file analysis then update MySQL database Filter information in a Simple List Find Model Problemas Foriegn key relationship Format currency forward/backward navigation and bookmark in ajax web app Generate and run locally on webratio professional edition. "Generation Error" with Generate and Run Generation options problem get the attachment files of an email getting data from database Get Unit problem Get Year from Date Groovy and Database Guardar Saltos de LINEA Help for connect public and private site views Hide a form if condition if true How can i create pagemenu or landmarkmenu with multiple levels. How can I import a view in the Domain Model as an attribute of an Entity? How database or datamodel migration? How does WebRatio represent these IFML elements? / ¿Cómo representa WebRatio estos elementos IFML? How I can receive the primary key value after adding into database from OK Port. How i can reuse modules in multiple projects? How to block empty string in Database How to define the sequence of execution units on a page? How to disble derby database? How to display the attributes of a related entity. How to filter imported attributes? How to fix Network error(status 0) How to include Selector Unit result in Mail Unit Body? How to pass vars to a alternative page How to process IFML Model (build with Eclipse editor) with ATL How to run web app with authentication service How to show a page based on a boolean? How to show certain values derived from relations in the domain model? How to speed up the "last" link using PowerIndexUnit for lots of records How to store data related to an entity in relationships in a project web I can't run any application with WebRatio (Table/View 'APP.POST' does not exist) Image in List field Insert data into database Insert master page to many hybrid modules Integrating a BPM model into an existent WebML model Is it possible to create a derived relationship between databases? JDBC4 Postgresql Driver JDBC connection with mysql on mac Job not start correctly JSON I/O Unit e informazioni derivate KO Links in Selector Unit Landmark in hybrid module Link localization Links from Index unit with condition Link Visibility Condition Power Index Unit Mail multipla maintain the record order in a sortable list Mapping database of the entity '...' is unspecified Math Unit to update attributes of an entity? [MOBILE] Can't synchronize domain model with beck end DB [MOBILE] How I extract information from JSON client side? Modifica Entità tramite file xml Mostrar datos de diferentes tablas/ show dates from diferentes entities MS SQL server jdbc file Multi Entry Unit: How to forward only checked rows? multi-lingual product description multi selections field problem MySQL Driver jdbc No Apache Derby driver found No Database on Cloud account No database on my cloud account Non riesco a fare funzionare Xml out unit Parametrizzazione Selector Unit Passing JSON Object to Model Personalizzare lo stile di un progetto PostgreSQL Predefined values in database Problem accessing MySQL with WebRatio 6 Problema Grafo da una lista gerarchica Problema ¨HTTP Status 404" Problemas con el Operations View Delete Problem Example create Unit (no company in employee table) Problem in adding diagrams in IFML Editor (Eclipse) Problem saving multi selection from input Problems to connect Sql Server DB from Webratio Problems with Database Metadata Problem with fields with accents used in attribute condition Problem with Scroller Unit Problem with stored procedure Problem with the deletion of more than 50.000 records in a table publish web service for storing information in PostgreSQL DB following XSD Resource query a database Question about Site Views Refresh and Synchronize DB Problems Relaciones Removing the User-Group-Module tagles Rename passing attributes Replace ID by its value in another table Retrieve a value and add some value to it reverse engineering, problema con le relazioni di default Script Unit e Mysql Search by Selector component does not work Select between parameters Selector unit doesn't return any value in hybrid module Sending mails is not working Sending mails with gmail is not working Setting the Default link for a Switch unit Share database connection show/hide fields on button click (registration page) [solved] all links transparent, why ? Solve "Generation Error" with Generate and Run option Something leads to wrong condition expression evaluation. Statistics Component for WebRatio > 7.2.0 Status ProcessInstance and activityInstance in spanish sumar atributos de una tabla filtrado por Role Condition Sum entity's values Sybase JConnect 4 JAR replace Sync DataService Project with Mobile Project Table 'freeapp43.profesion' doesn't exist Tarea de servicio no me evalua el valor Transportation Link issue Trying to Synchronize Domain Model Unable to execute the script java.lang.NullPointerException Unique Fields Unknow property on Dynaclass after generation Unspecified BPM Engine Database Update mutiple records with the same value upload file and the move it to other location User Login Timestamp Username come chiave Using own User and Group tables using relationship role conditional with null usuarios y grupos utilizzo componenti database Visibility Condition on Multiple Links From Index Unit Web ratio data model WebRatio - list results of joined tables Web Ratio Mobile and Foreign Key Web Ratio Mobile - Remote data mapping problem WebRation - Create Navigation diagram WebRatio no imports all attributes (fields) of a table Where is the ACME demo data stored?! White report